package com.maycurobj.repository.bpm;


import com.maycurobj.entity.bpm.PersonnelInfoDTO;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.stereotype.Repository;

import java.util.List;

/**
 * 取bpm员工信息
 */
@Repository
public interface PersonnelInfoMapper extends JpaRepository<PersonnelInfoDTO, String> {
    @Query(nativeQuery = true,value = "SELECT id,employeeNo,`name`,departmentId from h_org_user where status ='ENABLE' and employeeNo like 'ZJBS%'")
    List<PersonnelInfoDTO> getPersonnelInfo();


}
